﻿using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
namespace ZR.Model.mes.pro
{
    /// <summary>
    /// 生产计划
    ///</summary>
    [SugarTable("pro_workorder")]
    public class ProWorkorder
    {
        /// <summary>
        /// 计划年 
        ///</summary>
         [SugarColumn(ColumnName="workorder_year" ,IsPrimaryKey = true   )]
         public int WorkorderYear { get; set; }
        /// <summary>
        /// 计划月 
        ///</summary>
         [SugarColumn(ColumnName="workorder_month" ,IsPrimaryKey = true   )]
         public int WorkorderMonth { get; set; }
        /// <summary>
        /// 计划周 
        ///</summary>
         [SugarColumn(ColumnName="workorder_week" ,IsPrimaryKey = true   )]
         public int WorkorderWeek { get; set; }
        /// <summary>
        /// 工单编码/产品编码 
        ///</summary>
         [SugarColumn(ColumnName="workorder_code" ,IsPrimaryKey = true   )]
         public string WorkorderCode { get; set; }
        /// <summary>
        /// 工单名称/第（30)周生产计划 
        ///</summary>
         [SugarColumn(ColumnName="workorder_name"    )]
         public string WorkorderName { get; set; }
        /// <summary>
        /// 来源类型（1：客户订单（默认），2：生产备料） 
        ///</summary>
         [SugarColumn(ColumnName="order_source"    )]
         public string OrderSource { get; set; }
        /// <summary>
        /// 来源单据code 
        ///</summary>
         [SugarColumn(ColumnName="source_code"    )]
         public string SourceCode { get; set; }
        /// <summary>
        /// 班组 
        ///</summary>
         [SugarColumn(ColumnName="classgroup"    )]
         public string Classgroup { get; set; }
        /// <summary>
        /// 车型 
        ///</summary>
         [SugarColumn(ColumnName="vehicle"    )]
         public string Vehicle { get; set; }
        /// <summary>
        /// 生产产品零件号 
        ///</summary>
         [SugarColumn(ColumnName="product_id"    )]
         public string ProductId { get; set; }
        /// <summary>
        /// 生产产品编码 
        ///</summary>
         [SugarColumn(ColumnName="product_code"    )]
         public string ProductCode { get; set; }
        /// <summary>
        /// 生产产品名称 
        ///</summary>
         [SugarColumn(ColumnName="product_name"    )]
         public string ProductName { get; set; }
        /// <summary>
        /// 标准班产 
        ///</summary>
         [SugarColumn(ColumnName="standard_shift_production"    )]
         public string StandardShiftProduction { get; set; }
        /// <summary>
        /// 生产耗时 
        ///</summary>
         [SugarColumn(ColumnName="time_consumption"    )]
         public string TimeConsumption { get; set; }
        /// <summary>
        /// 本周装配计划数量 
        ///</summary>
         [SugarColumn(ColumnName="require_quantity"    )]
         public string RequireQuantity { get; set; }
        /// <summary>
        /// 单位 
        ///</summary>
         [SugarColumn(ColumnName="unit"    )]
         public string Unit { get; set; }
        /// <summary>
        /// 本周实际生产数量 
        ///</summary>
         [SugarColumn(ColumnName="quantity_produced"    )]
         public string QuantityProduced { get; set; }
        /// <summary>
        /// 数量调整 
        ///</summary>
         [SugarColumn(ColumnName="quantity_changed"    )]
         public string QuantityChanged { get; set; }
        /// <summary>
        /// 已排程数量 
        ///</summary>
         [SugarColumn(ColumnName="quantity_scheduled"    )]
         public string QuantityScheduled { get; set; }
        /// <summary>
        /// 客户id 
        ///</summary>
         [SugarColumn(ColumnName="client_id"    )]
         public string ClientId { get; set; }
        /// <summary>
        /// 客户code 
        ///</summary>
         [SugarColumn(ColumnName="client_code"    )]
         public string ClientCode { get; set; }
        /// <summary>
        /// 客户名称 
        ///</summary>
         [SugarColumn(ColumnName="client_name"    )]
         public string ClientName { get; set; }
        /// <summary>
        /// 父工单 
        ///</summary>
         [SugarColumn(ColumnName="parent_id"    )]
         public string ParentId { get; set; }
        /// <summary>
        /// 单据状态 
        ///</summary>
         [SugarColumn(ColumnName="status"    )]
         public string Status { get; set; }
        /// <summary>
        /// 备注 
        ///</summary>
         [SugarColumn(ColumnName="remark"    )]
         public string Remark { get; set; }
        /// <summary>
        /// 备用字段1 
        ///</summary>
         [SugarColumn(ColumnName="attr1"    )]
         public string Attr1 { get; set; }
        /// <summary>
        /// 备用字段2 
        ///</summary>
         [SugarColumn(ColumnName="attr2"    )]
         public string Attr2 { get; set; }
        /// <summary>
        /// 备用字段3 
        ///</summary>
         [SugarColumn(ColumnName="attr3"    )]
         public string Attr3 { get; set; }
        /// <summary>
        /// 租户号 
        ///</summary>
         [SugarColumn(ColumnName="TENANT_ID"    )]
         public string TenantId { get; set; }
        /// <summary>
        /// 乐观锁 
        ///</summary>
         [SugarColumn(ColumnName="REVISION"    )]
         public int? Revision { get; set; }
        /// <summary>
        /// 创建人 
        ///</summary>
         [SugarColumn(ColumnName="CREATED_BY"    )]
         public string CreatedBy { get; set; }
        /// <summary>
        /// 创建时间 
        ///</summary>
         [SugarColumn(ColumnName="CREATED_TIME"    )]
         public DateTime? CreatedTime { get; set; }
        /// <summary>
        /// 更新人 
        ///</summary>
         [SugarColumn(ColumnName="UPDATED_BY"    )]
         public string UpdatedBy { get; set; }
        /// <summary>
        /// 更新时间 
        ///</summary>
         [SugarColumn(ColumnName="UPDATED_TIME"    )]
         public DateTime? UpdatedTime { get; set; }
    }
}
